const Sequelize = require('sequelize')
const sequelize = require('../utils/db')

//定义表的模型
var User = sequelize.define('tblusers', {
  AutoID: { //自增长id,主键,整形
    type: Sequelize.INTEGER,
    primaryKey: true,
    autoIncrement: true
  },
  UserName: { //用户名
    type: Sequelize.STRING(20)
  },
  UserPhone: { //手机号
    type: Sequelize.STRING(11)
  },
  UserPassword: { //用户密码
    type: Sequelize.STRING(32)
  }
}, {
  timestamps: false
});
User.sync(); //创建表

module.exports = User;

